FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class > SetConditionalFormatting Method : SetConditionalFormatting(Int32,Int32,Boolean,IConditionalFormattingRule[]) Method |
'Declaration Public Overloads Sub SetConditionalFormatting( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal combinable As Boolean, _ ByVal ParamArray rules() As IConditionalFormattingRule _ )
'Usage Dim instance As SheetView Dim row As Integer Dim column As Integer Dim combinable As Boolean Dim rules() As IConditionalFormattingRule instance.SetConditionalFormatting(row, column, combinable, rules)
public void SetConditionalFormatting( int row, int column, bool combinable, params IConditionalFormattingRule[] rules )
protected void Page_Load(object sender, System.EventArgs e) { FpSpread1.Sheets[0].Cells[0, 0].Value = 3; FpSpread1.Sheets[0].Cells[1, 0].Value = 2; FpSpread1.Sheets[0].Cells[1, 1].Value = 10; FpSpread1.Sheets[0].Cells[0, 2].Value = 1; } protected void Button1_Click(object sender, EventArgs e) { FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule unary = new FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo, 10); unary.Operator = FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo; unary.Value = 10; unary.BackColor = Color.Red; unary.FontStyle = new FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.UnderlineFontStyle.None); unary.FontStyle.RegularBoldItalic = FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold; FarPoint.Web.Spread.BetweenValuesConditionalFormattingRule between = new FarPoint.Web.Spread.BetweenValuesConditionalFormattingRule(false, 1, false, 20, false); between.FirstValue = 1; between.SecondValue = 20; between.IsNotBetween = true; between.BackColor = Color.Bisque; //SetConditionalFormatting Overload FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, false, unary, between); //FpSpread1.ActiveSheetView.SetConditionalFormatting(new FarPoint.Web.Spread.Model.CellRange[] { new FarPoint.Web.Spread.Model.CellRange(1, 1, 2, 3), new FarPoint.Web.Spread.Model.CellRange(1, 2, 2, 1) }, unary, between); //FpSpread1.ActiveSheetView.SetConditionalFormatting(new FarPoint.Web.Spread.Model.CellRange[] { new FarPoint.Web.Spread.Model.CellRange(1, 1, 2, 3), new FarPoint.Web.Spread.Model.CellRange(1, 2, 2, 1) }, FarPoint.Web.Spread.ConditionalFormattingCompactMode.Solid, unary); //FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, unary); //FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, false, unary); //FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, unary, between); //FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, false, unary); }
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load FpSpread1.Sheets(0).Cells(0, 0).Value = 3 FpSpread1.Sheets(0).Cells(1, 0).Value = 2 FpSpread1.Sheets(0).Cells(1, 1).Value = 10 FpSpread1.Sheets(0).Cells(0, 2).Value = 1 End Sub Dim unary As New FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo, 10) unary.Operator = FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo unary.Value = 10 unary.BackColor = Drawing.Color.Red unary.FontStyle = New FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.UnderlineFontStyle.None) unary.FontStyle.RegularBoldItalic = FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold Dim between As New FarPoint.Web.Spread.BetweenValuesConditionalFormattingRule(False, 1, False, 20, False) between.FirstValue = 1 between.SecondValue = 20 between.IsNotBetween = True between.BackColor = Drawing.Color.Bisque 'SetConditionalFormatting Overload FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, False, unary, between) 'FpSpread1.ActiveSheetView.SetConditionalFormatting(New FarPoint.Web.Spread.Model.CellRange() {New FarPoint.Web.Spread.Model.CellRange(1, 1, 2, 3), New FarPoint.Web.Spread.Model.CellRange(1, 2, 2, 1)}, unary, between) 'FpSpread1.ActiveSheetView.SetConditionalFormatting(New FarPoint.Web.Spread.Model.CellRange() {New FarPoint.Web.Spread.Model.CellRange(1, 1, 2, 3), New FarPoint.Web.Spread.Model.CellRange(1, 2, 2, 1)}, FarPoint.Web.Spread.ConditionalFormattingCompactMode.Solid, unary) 'FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, unary) 'FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, False, unary) 'FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, unary, between) 'FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, False, unary)
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6